Entrée [1]:
Entrée [2]:
Entrée [3]:
Entrée [4]:
Entrée [5]:
Entrée [6]:
Entrée [7]:
Entrée [8]:
Entrée [9]:
Found existing installation: holidays 0.11.1
Uninstalling holidays-0.11.1:
  Successfully uninstalled holidays-0.11.1
Collecting holidays
  Using cached holidays-0.28-py3-none-any.whl (642 kB)
Requirement already satisfied: python-dateutil in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays) (2.8.2)
Requirement already satisfied: six>=1.5 in c:\users\vuseghesa\miniconda3\lib\site-packages (from python-dateutil->holidays) (1.16.0)
Installing collected packages: holidays
Successfully installed holidays-0.28
Entrée [10]:
Requirement already satisfied: holidays in c:\users\vuseghesa\miniconda3\lib\site-packages (0.28)
Requirement already satisfied: python-dateutil in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays) (2.8.2)
Requirement already satisfied: six>=1.5 in c:\users\vuseghesa\miniconda3\lib\site-packages (from python-dateutil->holidays) (1.16.0)
Entrée [11]:
Collecting holidays==0.11.1
  Using cached holidays-0.11.1-py3-none-any.whl (133 kB)
Requirement already satisfied: korean-lunar-calendar in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays==0.11.1) (0.3.1)
Requirement already satisfied: convertdate>=2.3.0 in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays==0.11.1) (2.4.0)
Requirement already satisfied: python-dateutil in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays==0.11.1) (2.8.2)
Requirement already satisfied: hijri-converter in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays==0.11.1) (2.3.1)
Requirement already satisfied: six in c:\users\vuseghesa\miniconda3\lib\site-packages (from holidays==0.11.1) (1.16.0)
Requirement already satisfied: pymeeus<=1,>=0.3.13 in c:\users\vuseghesa\miniconda3\lib\site-packages (from convertdate>=2.3.0->holidays==0.11.1) (0.5.12)
Installing collected packages: holidays
  Attempting uninstall: holidays
    Found existing installation: holidays 0.28
    Uninstalling holidays-0.28:
      Successfully uninstalled holidays-0.28
Successfully installed holidays-0.11.1
Entrée [12]:
Requirement already satisfied: plotly in c:\users\vuseghesa\miniconda3\lib\site-packages (5.15.0)Note: you may need to restart the kernel to use updated packages.

Requirement already satisfied: tenacity>=6.2.0 in c:\users\vuseghesa\miniconda3\lib\site-packages (from plotly) (8.2.2)
Requirement already satisfied: packaging in c:\users\vuseghesa\miniconda3\lib\site-packages (from plotly) (23.0)
Entrée [13]:
Entrée [14]:
Entrée [15]:
Entrée [16]:
Entrée [17]:
Entrée [18]:
IOT-temp.csv : (97606, 5)
Out[18]:
id room_id/id noted_date temp out/in
0 __export__.temp_log_196134_bd201015 Room Admin 08-12-2018 09:30 29 In
1 __export__.temp_log_196131_7bca51bc Room Admin 08-12-2018 09:30 29 In
2 __export__.temp_log_196127_522915e3 Room Admin 08-12-2018 09:29 41 Out
Entrée [19]:
Out[19]:
id room_id/id noted_date temp out/in outside inside
0 __export__.temp_log_196134_bd201015 Room Admin 08-12-2018 09:30 29 In 1 0
1 __export__.temp_log_196131_7bca51bc Room Admin 08-12-2018 09:30 29 In 1 0
2 __export__.temp_log_196127_522915e3 Room Admin 08-12-2018 09:29 41 Out 0 1
3 __export__.temp_log_196128_be0919cf Room Admin 08-12-2018 09:29 41 Out 0 1
4 __export__.temp_log_196126_d30b72fb Room Admin 08-12-2018 09:29 31 In 1 0
Entrée [20]:
Out[20]:
id room_id/id date temp place outside inside
0 __export__.temp_log_196134_bd201015 Room Admin 08-12-2018 09:30 29 In 1 0
1 __export__.temp_log_196131_7bca51bc Room Admin 08-12-2018 09:30 29 In 1 0
2 __export__.temp_log_196127_522915e3 Room Admin 08-12-2018 09:29 41 Out 0 1
Entrée [21]:
Entrée [22]:
Les valeurs 'In' sont :  20345
Les valeurs 'Out' sont :  77261
Les valeurs '29' sont :  7922
Entrée [23]:
Out[23]:
pandas.core.series.Series
Entrée [24]:
Out[24]:
Text(0.5, 1.0, 'place v/s Temp')
Entrée [25]:
Les valeurs '1' dans la colonne 'inside'sont :  77261
Les valeurs '1' dans la colonne 'outside'sont :  20345
Entrée [26]:
Entrée [27]:
Entrée [28]:
Les noeuds pris aléatoirement sont au nombre de :  90804
Entrée [29]:
Pourcentage noeud selectionnés :  93.03116611683708
Entrée [30]:
Entrée [31]:
Entrée [32]:
Out[32]:
Room Admin    97606
Name: room_id/id, dtype: int64
Entrée [33]:
Les valeurs '29' dans la colonne 'temp'sont :  7410
Les valeurs 'Out' dans la colonne 'place'sont :  71840
Les valeurs 'In' dans la colonne 'Place'sont :  18964
Les valeurs '1' dans la colonne 'outside'sont :  18964
Les valeurs '1' dans la colonne 'outside'sont :  71840
Entrée [34]:
                                        id  room_id/id              date  \
0      __export__.temp_log_196134_bd201015  Room Admin  08-12-2018 09:30   
1      __export__.temp_log_196131_7bca51bc  Room Admin  08-12-2018 09:30   
2      __export__.temp_log_196127_522915e3  Room Admin  08-12-2018 09:29   
3      __export__.temp_log_196128_be0919cf  Room Admin  08-12-2018 09:29   
4      __export__.temp_log_196126_d30b72fb  Room Admin  08-12-2018 09:29   
...                                    ...         ...               ...   
97601   __export__.temp_log_91076_7fbd08ca  Room Admin  28-07-2018 07:07   
97602  __export__.temp_log_147733_62c03f31  Room Admin  28-07-2018 07:07   
97603  __export__.temp_log_100386_84093a68  Room Admin  28-07-2018 07:06   
97604  __export__.temp_log_123297_4d8e690b  Room Admin  28-07-2018 07:06   
97605  __export__.temp_log_133741_32958703  Room Admin  28-07-2018 07:06   

       temp place  outside  inside  
0        15    In        1       0  
1        15    In        1       0  
2        41   Out        0       1  
3        41   Out        0       1  
4        31    In        1       0  
...     ...   ...      ...     ...  
97601    31    In        1       0  
97602    31    In        1       0  
97603    31    In        1       0  
97604    31    In        1       0  
97605    31    In        1       0  

[97606 rows x 7 columns]
Entrée [35]:
Out[35]:
id date temp place outside inside
0 __export__.temp_log_196134_bd201015 08-12-2018 09:30 15 In 1 0
1 __export__.temp_log_196131_7bca51bc 08-12-2018 09:30 15 In 1 0
2 __export__.temp_log_196127_522915e3 08-12-2018 09:29 41 Out 0 1
Entrée [36]:
Out[36]:
id date temp place outside inside
0 __export__.temp_log_196134_bd201015 08-12-2018 09:30 15 In 1 0
1 __export__.temp_log_196131_7bca51bc 08-12-2018 09:30 15 In 1 0
2 __export__.temp_log_196127_522915e3 08-12-2018 09:29 41 Out 0 1
Entrée [37]:
Out[37]:
id date temp place outside inside year month day weekday weekofyear hour minute
0 __export__.temp_log_196134_bd201015 2018-12-08 09:30:00 15 In 1 0 2018 12 8 Saturday 49 9 30
1 __export__.temp_log_196131_7bca51bc 2018-12-08 09:30:00 15 In 1 0 2018 12 8 Saturday 49 9 30
2 __export__.temp_log_196127_522915e3 2018-12-08 09:29:00 41 Out 0 1 2018 12 8 Saturday 49 9 29
Entrée [38]:
Entrée [39]:
Out[39]:
id date temp place outside inside year month day weekday weekofyear hour minute season
0 __export__.temp_log_196134_bd201015 2018-12-08 09:30:00 15 In 1 0 2018 12 8 Saturday 49 9 30 Winter
1 __export__.temp_log_196131_7bca51bc 2018-12-08 09:30:00 15 In 1 0 2018 12 8 Saturday 49 9 30 Winter
2 __export__.temp_log_196127_522915e3 2018-12-08 09:29:00 41 Out 0 1 2018 12 8 Saturday 49 9 29 Winter
Entrée [40]:
Entrée [41]:
Out[41]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
0 __export__.temp_log_196134_bd201015 2018-12-08 09:30:00 15 In 1 0 2018 12 8 Saturday 49 9 30 Winter Morning
1 __export__.temp_log_196131_7bca51bc 2018-12-08 09:30:00 15 In 1 0 2018 12 8 Saturday 49 9 30 Winter Morning
2 __export__.temp_log_196127_522915e3 2018-12-08 09:29:00 41 Out 0 1 2018 12 8 Saturday 49 9 29 Winter Morning
Entrée [42]:
Out[42]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
11 __export__.temp_log_196108_4a983c7e 2018-12-08 09:25:00 42 Out 0 1 2018 12 8 Saturday 49 9 25 Winter Morning
Entrée [43]:
Out[43]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
10 __export__.temp_log_196108_4a983c7e 2018-12-08 09:25:00 42 Out 0 1 2018 12 8 Saturday 49 9 25 Winter Morning
11 __export__.temp_log_196108_4a983c7e 2018-12-08 09:25:00 42 Out 0 1 2018 12 8 Saturday 49 9 25 Winter Morning
Entrée [44]:
Out[44]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
Entrée [45]:
Out[45]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
61229 __export__.temp_log_101144_ff2f0b97 2018-09-12 03:09:00 15 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
61258 __export__.temp_log_101502_172517d2 2018-09-12 03:09:00 15 In 1 0 2018 9 12 Wednesday 37 3 9 Monsoon Night
61255 __export__.temp_log_104868_a5e526b3 2018-09-12 03:09:00 28 In 1 0 2018 9 12 Wednesday 37 3 9 Monsoon Night
61231 __export__.temp_log_108845_062b2592 2018-09-12 03:09:00 28 In 1 0 2018 9 12 Wednesday 37 3 9 Monsoon Night
61272 __export__.temp_log_112303_fca608f4 2018-09-12 03:09:00 15 In 1 0 2018 9 12 Wednesday 37 3 9 Monsoon Night
Entrée [46]:
Out[46]:
True
Entrée [47]:
Out[47]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
0 196134 2018-12-08 09:30:00 15 In 1 0 2018 12 8 Saturday 49 9 30 Winter Morning
1 196131 2018-12-08 09:30:00 15 In 1 0 2018 12 8 Saturday 49 9 30 Winter Morning
2 196127 2018-12-08 09:29:00 41 Out 0 1 2018 12 8 Saturday 49 9 29 Winter Morning
Entrée [48]:
Out[48]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
61273 17002 2018-09-12 03:09:00 15 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
61275 17003 2018-09-12 03:09:00 28 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
61267 17006 2018-09-12 03:09:00 28 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
61269 17009 2018-09-12 03:09:00 28 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
61271 17010 2018-09-12 03:09:00 15 Out 0 1 2018 9 12 Wednesday 37 3 9 Monsoon Night
Entrée [49]:
Out[49]:
id date temp place outside inside year month day weekday weekofyear hour minute season timing
84141 4000 2018-09-09 16:24:00 15 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
84142 4002 2018-09-09 16:24:00 15 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
84144 4004 2018-09-09 16:23:00 28 Out 0 1 2018 9 9 Sunday 36 16 23 Monsoon Afternoon
84128 4006 2018-09-09 16:24:00 28 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
84132 4007 2018-09-09 16:24:00 15 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
84136 4009 2018-09-09 16:24:00 28 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
84137 4010 2018-09-09 16:24:00 28 Out 0 1 2018 9 9 Sunday 36 16 24 Monsoon Afternoon
Entrée [50]:
Out[50]:
Entrée [51]:
Out[51]:
Entrée [52]:
Out[52]:
Entrée [53]:
Out[53]:
Entrée [54]:
Out[54]:
Entrée [55]:
Out[55]:
Entrée [56]:
Out[56]:
Entrée [57]:
Out[57]:
Entrée [58]:
Out[58]:
Entrée [59]:
Out[59]:
date temp place outside inside year month day weekday weekofyear hour minute season timing
0 2018-07-28 07:06:00 31.0 In 1 0 2018 7 28 Saturday 30 7 6 Monsoon Morning
1 2018-07-28 07:07:00 31.0 Out 0 1 2018 7 28 Saturday 30 7 7 Monsoon Morning
2 2018-07-28 07:07:00 32.0 In 1 0 2018 7 28 Saturday 30 7 7 Monsoon Morning
Entrée [60]:
Out[60]:
Entrée [61]:
Out[61]:
Entrée [62]:
Out[62]:
Entrée [63]:
Out[63]:
Entrée [64]:
Out[64]:
Entrée [65]:
Out[65]:
Entrée [66]:
Out[66]:
daily In Out season_Monsoon season_Post_Monsoon season_Winter
0 2018-07-28 31.142857 31.691667 1 0 0
1 2018-07-29 32.500000 31.333333 1 0 0
2 2018-07-30 33.034577 31.643223 1 0 0
Entrée [67]:
Entrée [68]:
Out[68]:
Text(0.5, 1.0, 'Place v/s Temp')
Entrée [69]:
INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_36180\2455996595.py:37: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig1.show()
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_36180\2455996595.py:41: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig2.show()
Entrée [70]:
INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_36180\2455996595.py:37: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig1.show()
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_36180\2455996595.py:41: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig2.show()
Entrée [71]:
Out[71]:
Entrée [72]:
Out[72]:
Entrée [73]:
INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_36180\2455996595.py:37: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig1.show()
INFO:fbprophet:Disabling daily seasonality. Run prophet with daily_seasonality=True to override this.
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\miniconda3\lib\site-packages\fbprophet\forecaster.py:891: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  components = components.append(new_comp)
C:\Users\VUSEGHESA\AppData\Local\Temp\ipykernel_36180\2455996595.py:37: UserWarning: Matplotlib is currently using module://matplotlib_inline.backend_inline, which is a non-GUI backend, so cannot show the figure.
  fig1.show()
Entrée [ ]: